.jpg)
You are here: Building the Model: Advanced Elements > External Files > File Types > Entity-Location File
An Entity-Location file (or expression file) is a spreadsheet (.wk1 or .xls format only) file containing numeric expressions listed by entity and location name. Entity names should appear across the top row, beginning in column 2, while location names should be entered down the first column, beginning on row 2. A numeric expression for each Entity-Location combination is entered in the cell where the names intersect. An example of a spreadsheet file is shown next.
To use the value stored in an Entity-Location file as an operation time, call out the file identifier in the operation logic as shown in the following example. (In this example, "SvcTms" is the File ID of the desired Entity-Location file.)
Please note
If the .wk1 or .xls file contains more than one sheet of data, only the first sheet will be read in.
Process Table
|
Entity |
Location |
Operation (min) |
|---|---|---|
|
EntA |
Loc1 |
WAIT SvcTms() |
Routing Table
|
Blk |
Output |
Destination |
Rule |
Move Logic |
|---|---|---|---|---|
|
1 |
EntA |
Loc2 |
FIRST 1 |
MOVE FOR 5 |
By specifying SvcTms() with no arguments in the parentheses, a value is returned from the Entity-Location File "SvcTms" for the current entity at the current location, i.e., EntA at Loc1. You may also return the value stored in any other cell of an Entity-Location file by explicitly specifying the entity and location names in the parentheses, e.g., SvcTms(EntB, Loc1) or SvcTms(EntC, Loc2).